How to: Create a table by linking existing data.
Solution:
Click the 'Tables' tab in the Database window, click 'New', and select 'Link Table'.
NOTE: Never include a calculated field in the table.
1) If the Database window is not active, activate the Database window.
2) Click the 'Tables' tab in the Database window.
Tables tab
3) Click 'New'. (The New Table dialog box appears.)
4) Select 'Link Table' from the list box.
5) Click 'OK'. (The Link dialog box appears.)
6) Select the desired folder from the 'Look in' drop-down list box.
7) Select the file containing the data from the 'Look in' list box.
8) Select the file type from the 'Files of Type' drop-down list box.
9) Click 'Link'. (Depending on the type of file selected, the appropriate Link Wizard dialog box appears.)
10) Follow the instructions in the wizard dialog boxes.
11) Click 'Finish' when all entries and selections have been made.
